﻿<?xml version="1.0"?>
<CsvDataLoaderParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableMetadataEntity>
    <Name>Service Requests</Name>
    <Category>Government Operations</Category>
    <Description>This dataset provides summary reports of service requests submitted to the Mayor's Call Center and the online Service Request Center</Description>
    <Source>Office of Customer Service Operations</Source>
    <LastUpdateDate>2009-03-31T00:00:00</LastUpdateDate>
    <MetadataUrl>http://data.octo.dc.gov/Metadata.aspx?id=4</MetadataUrl>
    <EntitySet>ServiceRequests</EntitySet>
    <EntityKind>ServiceRequest</EntityKind>
  </TableMetadataEntity>
  <ProducerParams>
    <PlacemarkParams>
      <LatitudeProperty>LATITUDE</LatitudeProperty>
      <LongitudeProperty>LONGITUDE</LongitudeProperty>
      <NamePropertyFormatString>Code: {0} Due: {1} Status: {2} Id: {3}</NamePropertyFormatString>
      <NameProperties>
        <string>SERVICETYPECODEDESCRIPTION</string>
        <string>SERVICEDUEDATE</string>
        <string>SERVICEORDERSTATUS</string>
        <string>SERVICEREQUESTID</string>
      </NameProperties>
    </PlacemarkParams>
    <PropertyToTypeMap>
      <SERVICEREQUESTID>string</SERVICEREQUESTID>
      <SERVICEPRIORITY>string</SERVICEPRIORITY>
      <SERVICECODE>string</SERVICECODE>
      <SERVICECODEDESCRIPTION>string</SERVICECODEDESCRIPTION>
      <SERVICETYPECODE>string</SERVICETYPECODE>
      <SERVICETYPECODEDESCRIPTION>string</SERVICETYPECODEDESCRIPTION>
      <SERVICEORDERDATE>DateTime</SERVICEORDERDATE>
      <SERVICEORDERSTATUS>string</SERVICEORDERSTATUS>
      <SERVICECALLCOUNT>Int32</SERVICECALLCOUNT>
      <AGENCYABBREVIATION>string</AGENCYABBREVIATION>
      <INSPECTIONFLAG>string</INSPECTIONFLAG>
      <INSPECTIONDATE>DateTime</INSPECTIONDATE>
      <RESOLUTION>string</RESOLUTION>
      <RESOLUTIONDATE>DateTime</RESOLUTIONDATE>
      <SERVICEDUEDATE>DateTime</SERVICEDUEDATE>
      <SERVICENOTES>string</SERVICENOTES>
      <PARENTSERVICEREQUESTID>string</PARENTSERVICEREQUESTID>
      <ADDDATE>DateTime</ADDDATE>
      <LASTMODIFIEDDATE>DateTime</LASTMODIFIEDDATE>
      <SITEADDRESS>string</SITEADDRESS>
      <LATITUDE>double</LATITUDE>
      <LONGITUDE>double</LONGITUDE>
      <ZIPCODE>string</ZIPCODE>
      <MARADDRESSREPOSITORYID>string</MARADDRESSREPOSITORYID>
      <DCSTATADDRESSKEY>string</DCSTATADDRESSKEY>
      <DCSTATLOCATIONKEY>string</DCSTATLOCATIONKEY>
      <WARD>string</WARD>
      <ANC>string</ANC>
      <SMD>string</SMD>
      <DISTRICT>string</DISTRICT>
      <PSA>string</PSA>
      <NEIGHBORHOODCLUSTER>string</NEIGHBORHOODCLUSTER>
      <HOTSPOT2006NAME>string</HOTSPOT2006NAME>
      <HOTSPOT2005NAME>string</HOTSPOT2005NAME>
      <HOTSPOT2004NAME>string</HOTSPOT2004NAME>
    </PropertyToTypeMap>
  </ProducerParams>
  <ProcessorParams>
    <PartitionKeyPropertyName>SERVICEORDERDATE</PartitionKeyPropertyName>
    <RowKeyPropertyName>SERVICEREQUESTID</RowKeyPropertyName>
    <TableMetadataPartitionKeyPropertyName>Name</TableMetadataPartitionKeyPropertyName>
    <TableMetadataRowKeyPropertyName>New.Guid</TableMetadataRowKeyPropertyName>
    <EntityMetadataPartitionKeyPropertyName>EntitySet</EntityMetadataPartitionKeyPropertyName>
    <EntityMetadataRowKeyPropertyName>EntityKind</EntityMetadataRowKeyPropertyName>
  </ProcessorParams>
</CsvDataLoaderParams>